﻿CREATE PROCEDURE [SSIS].[GetSolutionEnvironmentVariable](
	@EnvironmentID bigint
	,@VariableName sysname
	,@VariableValue sql_variant OUTPUT
)
AS
BEGIN
	SELECT @VariableValue = [value]
	FROM [$(SSISDB)].[internal].[environment_variables]
	WHERE  ([environment_id] = @EnvironmentID)
		AND([name] = @VariableName);
				
	RETURN(0);
END
GO